﻿--HEADER Added column [Flags] to [Analytics].[Investment] table

WHILE EXISTS(SELECT NULL FROM [Analytics].[Idea])
BEGIN
	DELETE TOP(500) FROM [Analytics].[Idea]
END

GO

ALTER TABLE [Analytics].[Investment]
ADD Flags TINYINT NOT NULL

GO

ALTER TABLE [Analytics].[Investment]
DROP COLUMN IsNoise

GO

ALTER TABLE [Analytics].[Investment]
DROP COLUMN IsInErrorState